🦸 Run a Continuous Migration Job
Relational Migrator allows you to use Change-Data-Capture processes to continously synchronize data in your MongoDB database with changes made in your source database. When a continous migration is requested, Relational Migrator will first complete a normal full synchronization before entering Chane Data Capture mode. Change Data Capture synchronization will continue until you explicitly complete it.
To start a continuous migration job, switch to the Data Migration tab:
- Click
Create migration job - Specify the source DB connection details
- If you previously saved your connection details, you will be able to select those without needing to re-enter any details
- Specify MongoDB connection details
- Enter the URI, database, username and password for your MongoDB cluster
- If you are using Atlas, you can retrieve the details from the Atlas portal
- If you saved your MongoDB connection details during a previous migration, you will be able to select those without needing to re-enter any details
- Specify migration options
- Set Mode to
Continous - Choose the
Drop destination collections before migrationoption
- Set Mode to
- If you get a message warning you the source database is not configured for continous migration jobs
- Click the
Generate Scriptbutton to generate and download the SQL script to configure the database - Use pgAdmin or psql to run the script against the library database
- Click the
info
In an intructor-led lab, the provisioned PostgreSQL database will already be configured for continous migration.
info
If you need to install pgAdmin, it can be downloaded from here
- Read the migration job summary and confirm the details are correct
- If everything looks good, click
Start - Monitor the progress of the job
